Default Values

Creating a new mandatory attribute or making changes to an existing mandatory attribute adds a default value of "Unknown" to all the feature attribute sets. The following script can be run to set the default value to a specified value.

Example

You have used the Configuration Assistant to add a new mandatory attribute called Material, which adds a default value of "Unknown" to every attribute set.
You would now like to set the default value to "AL" instead of "Unknown" for the Splice feature.

Run the following script:

-- The following script updates Default Values for all current Attribute Sets for the specified Feature Attribute with the specified Default Value:

-- Replace the following values as needed. -- Feature: 'Splice' -- Attribute: 'Material' -- Default Value: 'AL'

update attributedefaultvalue

set textval = 'AL',

attributelegalvalueid = (select id from attributelegalvalue where value = 'AL')

where featureattributeid = (select id from featureattribute where name = 'Material'

and featuretypeid = (select id from featuretype where name = 'Splice'));

commit;